SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwecupos
AS
SELECT     idcupo AS ID, CicloLectivo, Organizacion, Carrera, Curso, CantidadDeCupos, CantidadDeDivisiones
FROM         dbo.tb_cupos
GO
GRANT SELECT ON  [dbo].[vwecupos] TO [Alumnos]
GRANT INSERT ON  [dbo].[vwecupos] TO [Alumnos]
GRANT DELETE ON  [dbo].[vwecupos] TO [Alumnos]
GRANT UPDATE ON  [dbo].[vwecupos] TO [Alumnos]
GRANT SELECT ON  [dbo].[vwecupos] TO [Coordinaciones]
GRANT INSERT ON  [dbo].[vwecupos] TO [Coordinaciones]
GRANT DELETE ON  [dbo].[vwecupos] TO [Coordinaciones]
GRANT UPDATE ON  [dbo].[vwecupos] TO [Coordinaciones]
GRANT SELECT ON  [dbo].[vwecupos] TO [SoloVer]
GO
